BI Engineer - SSIS, SSRS, SSAS | ETL Location: El Segundo, CA Duration: 6+ Months Position Summary: The Senior Software Engineer - BI architects, designs, and develops business intelligence, ETL and database solutions that support Advantage Sales and Marketing business units (Sales, Marketing, HR, etc) Serves as the project lead for small to mid-sized projects and primary point of contact for client stakeholders Manages stakeholders, gather requirements, design solutions, write and review code Work with many technologies and serves as the subject matter expert on select technologies or platforms Engage directly with the business stakeholder and is the bridge between the business and the technical team Guide the development of business intelligence and database projects Own small to mid-sized system Essential Job Duties and Responsibilities: Software Development Architect, design, develop, test, and deploy code for business intelligence and database technology platforms Plan and execute efforts to address technical debt for legacy systems and processes Share acquired skills/knowledge with team members and mentor junior engineers Project Leadership Lead efforts to gather and convert business requirements into functional designs and wireframes Architect and develop solutions for complex business problems Provide guidance to a team of developers, analysts and testers Develop and enforce development best practices Lead code reviews and technical exchange sessions Manage the development and maintenance of technical documents End User Support Triage and troubleshoot issues with users Identify patterns in user issues and recommend solutions that addresses root causes. Manage user training and onboarding activities. Experience: 6+ years of significant experience with SQL Server, SSIS, SSRS 6+ years of relevant experience with Systems Analysis and documentation Deep knowledge of related technologies such as SSAS, Microsoft and third party BI tools, .NET Current experience presenting technical solutions to business and technical audiences Experience managing business clients or customers Experience managing multiple phases of the SDLC Skills & Competencies: Ability to understand a business process and translate to a data model Ability to analyze ambiguous technical and customer situations and determine appropriate solutions as necessary Advanced skills in analytical design of software to be developed or configured to meet business needs Ability to develop sound technical documents Ability to share knowledge and expertise with other software engineers Proficient with agile development methodologies / Scrum Strong organizational skills Be a strong team builder Strong work ethic, self-motivated Advanced analytical thinking and problem solving skills Advanced written and oral communication skills Tools/Software Experience architecting systems and leading a small team in a Microsoft BI development environment: SQL Server 2008 (or newer) Microsoft Visual Studio Microsoft Team Foundation Server Microsoft Office SharePoint Third party BI visualization and end user tools Working knowledge of related systems and platforms:.NET, Active Directory, BizTalk, Dynamics and application architecture
Key Skills: